TG: oracle_dbd/920

Forwarded from Pavel V

Таблица sales_data — 50 млн записей.
Колонки:
a) region — 10 уникальных значений; b) product_category — 12 типов; c) sales_channel — 3 канала продаж; d) amount — сумма покупки Какая стратегия индексирования даст наилучшую производительность?

Anonymous Quiz

Один составной B-tree индекс (region, product_category, sales_channel)

Bitmap-индексы на каждую из трех колонок

Bitmap только на sales_channel

Индексы не нужны — всё читаем full scan’ом

226 answered

www.tg-me.com/kr/Oracle Developer‍/com.oracle_dbd/920

1.3K viewsMay 26 at 11:30

tg-me.com/oracle_dbd/920

Create: 2025-05-26
Last Update: 2025-07-02 22:46:49

BY Oracle Developer👨🏻‍💻

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/oracle_dbd/920

Oracle Developer‍ Telegram | DID YOU KNOW?

If riding a bucking bronco is your idea of fun, you’re going to love what the stock market has in store. Consider this past week’s ride a preview.The week’s action didn’t look like much, if you didn’t know better. The Dow Jones Industrial Average rose 213.12 points or 0.6%, while the S&P 500 advanced 0.5%, and the Nasdaq Composite ended little changed.

Importantly, that investor viewpoint is not new. It cycles in when conditions are right (and vice versa). It also brings the ineffective warnings of an overpriced market with it.Looking toward a good 2022 stock market, there is no apparent reason to expect these issues to change.